package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "c_merchant_pro", simpleName = "", engine = MysqlDriver.InnoDB, comment = "商户签约")
public class _DDL_CMerchantPro {

    @_DDL_Primary()
    @_DDL_Column(name = "pro_id", type = SqlType.INT_UNSIGNED, nullable = false, autoIncrement = true, comment = "id")
    private Long id;

    @_DDL_Column(name = "ag_id", type = SqlType.INT_UNSIGNED, comment = "渠道商id")
    private Long agId;

    @_DDL_Column(name = "mer_id", type = SqlType.BIGINT_UNSIGNED, comment = "商户id")
    private java.math.BigInteger merId;

    @_DDL_Column(name = "pro_type", type = SqlType.VARCHAR, size = 1, comment = "结算类型")
    private String type;

    @_DDL_Column(name = "pro_days", type = SqlType.TINYINT_UNSIGNED, comment = "计算周期")
    private Integer days;

    @_DDL_Column(name = "pro_begin_date", type = SqlType.VARCHAR, size = 10, comment = "协议开始日期")
    private String beginDate;

    @_DDL_Column(name = "pro_end_date", type = SqlType.VARCHAR, size = 10, comment = "协议结束日期")
    private String endDate;

    @_DDL_Column(name = "pro_ag_rate", type = SqlType.DECIMAL, size = 6, scale = 2, comment = "协议渠道商费率(万分之1)")
    private java.math.BigDecimal agRate;

    @_DDL_Column(name = "pro_rate", type = SqlType.DECIMAL, size = 6, scale = 2, comment = "协议费率(万分之1)")
    private java.math.BigDecimal rate;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "")
    private java.sql.Timestamp crTime;

}
